﻿if exists (select * from sysobjects where id = object_id(N'pBUGLOGUsersGet') and sysstat & 0xf = 4) drop procedure pBUGLOGUsersGet 
GO

-- Returns a specific record from the [dbo].[Users] table.
CREATE PROCEDURE pBUGLOGUsersGet
        @pk_UserID int
AS
DECLARE
    @l_count int
BEGIN

    -- Get the rowcount first and make sure 
    -- only one row is returned
    SELECT @l_count = count(*) 
    FROM [dbo].[Users]
    WHERE [UserID] =@pk_UserID

    IF @l_count = 0
        RAISERROR ('The record no longer exists.', 16, 1)
    IF @l_count > 1
        RAISERROR ('duplicate object instances.', 16, 1)

    -- Get the row from the query.  Checksum value will be
    -- returned along the row data to support concurrency.
    SELECT 
        [UserID],
        [UserName],
        [FirstName],
        [LastName],
        [Department],
        [Address],
        [phoneNumber],
        [EmailAddress],
        [RegistrationDate],
        [RoleID],
        CAST(BINARY_CHECKSUM([UserID],[UserName],[FirstName],[LastName],[Department],[Address],[phoneNumber],[EmailAddress],[RegistrationDate],[RoleID]) AS nvarchar(4000)) AS IS_CHECKSUM_COLUMN_12345
    FROM [dbo].[Users]
    WHERE [UserID] =@pk_UserID
END

